EMT Practice Test

1. Question Content...


Question List

Question1: Northern Trail Outfitters wants to integrate Marketing Cloud with its existing point-of-sale system in order in email purchase receipt to its customers. The point-of-sale data will need to be transformed to be received by the Marketing Cloud triggered send API.
What extension product should be used to accomplish this integration?

Question2: A customer wants Sales Cloud users to create and send Marketing Cloud emails.
Which two recommendations should the consultant make? Choose 2 answers

Question3: A consultant wants to trigger an email whenever the status field on the Lead Object changes to Hot, Tracking data will need to be kept in the sales cloud.
Which three steps should the consultant use in the solution

Question4: Northern Trail Outfitters wants to suppress their highly engaged email subscribers (multiple opens and clicks for a target campaign) from active display campaigns to reduce overall cost and eliminate unnecessary targeting to the user.
What should be recommended?

Question5: Northern Trail Outfitters wants to build an abandoned cart journey which includes a Decision Split that evaluates if a customer has made a purchase after they enter the journey. Customer data is stored in a master data extension ans purchase data is stored in a second data extension.
Which two steps should they include to accomplish this journey?

Question6: A customer wants to configure appointment reminders for patients in their clinic. The reminder should be sent day before the appointment date at 10 a.m and the appointment record should be updated in the patient was sent a reminder email.
What solution could be recommended?

Question7: Northern Trails Outfitters has a contact count of nearly 10 million records. They have noticed slower processing times when sending using Journey Builder.
Which two actions could they take to optimize Journey performance? (Choose 2 answers)

Question8: Northern Trail Outfitters wants to import their Sales Cloud data into Marketing Cloud to leverage it within Journey Builder. They have approximately 10 million customers and the data needs to be available with a delay of no more than 30 minutes. Only customers where the consent checkbox is selected in Sales Cloud should be imported, which represents approximately half of their customer database What should they implement?

Question9: Northern Trail Outfitters recently upgraded their preference center to allow customers to indicate which products they are interested in and to have the ability to opt up and down in send volume. They would like to configure the Delivery Options in a Journey Builder Email Activity to take these new data points into account.
Which two options could allow them to meet the requirement?
Choose 2 answers

Question10: An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal obligation due to the nature of their messages.
What method should be suggested in this scenario?

Question11: Analyst of The Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting. These metrics need to be reported per email campaign for each of NTO's Business Units:
* Number of Sends
* Delivery Rate
* Overall Bounce Rate
* Block Bounce Rate
* Open Rate
* Click Rate
* Complaint Rate
* Unsubscribe Rate
Which email report should NTO's Marketing Analyst pull from Marketing Cloud to get this information?

Question12: A retail company does business in both the United States and Canad
a. They have a loyalty program in which a customer can enroll. The company will provide a pre-segmented customer file, per campaign, which has a "Version" data field indicating the type of email the customer is to receive.
Which two questions should be asked to determine a data/segmentation strategy?
Choose 2 answers

Question13: A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The corporate office the advertising copy and subscriber list. The owners of franchised stores add a customized local message to the marketing campaign.
What hierarchy should be recommended?

Question14: A mobile contact is not receiving SMS messages sent via MobileConnect.
In which two ways could a consultant troubleshoot this issue? (Choose 2 answers)

Question15: A company collects subscriptions on its websites. It does the following:
* Compiles that subscription list in a database in the website content Management System (CMS).
* Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
* Uses Marketing Cloud as the database of record.
* Sends up to five emails a week based on subscriber engagement with prior sends.
What automation sequence (excluding waits) should cover these requirements?

Question16: Northern Trail Outfitters wants to export a data file to its SFTP using Automation Studio. The file should contain all subscribers who did not receive their intended email in the last 24 hours. The automation will be scheduled to run each day.
Which activity Is required in the automation?

Question17: Northern Trails Outfitters has a contact count of nearly 10 million records. They have noticed slower processing times when sending using Journey Builder.
Which two actions could they take to optimize Journey performance? (Choose 2 answers)

Question18: Northern Trail Outfitters (NTO) needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks:
* Maintain NTO's master suppression list
* Configure data relationships
* Create new subscriber attributes
Which role should be assigned to the IT staff member?

Question19: A customer manually imports records for sending. Each record contains a warehouse ID that is shared between Marketing Cloud and a third-party system. The customer does not have developer resources, but wants to include the warehouse ID in their tracking parameters so that the third-party system can identify the subscriber.
What should a consultant recommend?

Question20: Nothern Trail Outfitters wants to enable Sales Cloud users to manually create a segment of both lead and contact records that can be targeted through the Send Flow in Content Builder.
What should a consultant recommend for segmentation?

Question21: Northern Trail Outfitters has purchased a new Marketing Cloud account with two dedicated IP addresses. One IP address will be used for commercial sends, while the other will be reserved for transactional messages.
Their customer base includes 1.5 million email addresses.
What should the consultant recommend?

Question22: A customer frequently holds seminars and other events to interface with their customers. They plan to do the following:
*Use SmartCapture forms to write data into event registration data extensions.
*Cross-reference the records in each registration data extension with corresponding invitation email sends.
*Send a follow-up email to customers who click on the registration link in the invitation email, but do not complete registration.
Which skill is needed to build an efficient solution?

Question23: Northern Trail Outfitters has a customer login page on their website and wants to use Marketing Cloud to send an email to customers who need to reset their password. The email needs to be sent as quickly as possible. Their web server should receive a notification when the email is sent.
Which solution should they use?

Question24: A consulting has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed.
Which import type should be used?

Question25: A customer wants to create a journey with the goal of making users activate their accounts within 72 h of registration. New account registrations are stored in a data extension via an API call with a Boolean field indicating whether the subscriber has activated their account. The journey should send activation reminder emails 24 and 48 h after creating an account. The user exits the journey if they activate their account.
Which activities should be included in the customer's journey?

Question26: A customer wants to display a subscriber's first name and the date of send in its monthly newsletter. Subscriber first name data is stored in a data extension that will not be used in the send definition.
Which option should be in this scenario?

Question27: Northern Trail Outfitters is expanding globally into 16 new countries and wants to start localizing their email content to speak to subscribers in their own language. They want to do this as efficiently as possible and are anticipating growth into other locales in the near future.
Which two options could be recommended? (Choose 2 answers)

Question28: Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed.
What should the consultant do to diagnose the issue?

Question29: What statements are correct regarding Attribute Groups?
Choose 2 answers

Question30: NTO wants not only to send to their best customers, but also those most likely to buy.
What data will be helpful to send out an email which increases purchase frequency? Choose All that apply

Question31: Northern Trail Outfitters (NTO) is launching a new subsidiary brand, Cloud Kicks, within the next six months. Cloud Kicks anticipates sending approximately 50,000 emails per month from a child business unit. NTO will execute a large campaign announcing and associating itself with Cloud Kicks as part of the brand kickoff and is comfortable sharing digital properties with them. Cloud Kicks wants to utilize a custom sending domain, but deliverability is a primary concern.
What approach should be recommended?

Question32: Northern Trail Outfitters (NTO) wants to import recent customer transaction data from their data warehouse into Marketing Cloud on a nightly basis. They plan to create a File Drop Automation to trigger an automation when a data file is transferred from the data warehouse to the import folder in their Enhanced FTP account. NTO notes that user passwords expire every 90 days and they do not want to update their file transfer script on the data warehouse each time a password changes and they do not want to compromise security.
Which solution should the consultant recommend?

Question33: NTO wants to import files at certain standard times, but occasionally a file will be dropped on a Friday if the
30th of the month falls on a weekend.
What is the flow?

Question34: During discovery a consultant confirmed:
*A master audience file containing contact information and data points will be used for segmentation and imported nightly.
*The customer would like to implement a mechanism that consistently prevents sending promotional emails to subscribers who work for their top three competitors.
What feature should a consultant include in the solution?

Question35: Northern Trail Outfitters wants to target Contacts in an abandoned cart Journey with a Facebook ad. An Ad Campaign Activity has been added to the Journey canvas.
Which extension product should be enabled to use the Ad Campaign Activity?

Question36: Which two statements are accurate regarding segmentation options in Marketing Cloud? Choose 2 answers

Question37: Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.
How should this distributor-specific sender profile be configured in the Marketing Cloud?
Choose 2 answers

Question38: Northern Tril Outfitters wants to connect relational data into their Journey without overloading the entry data.
How should they connect the data?

Question39: A customer has an email newsletter to send out, but wants to deliver it with a targeted message for customers within a specified age range. These data have been defined in attributes from a sign-up landing page.
How should the customer individualize the email content?

Question40: Northern Trail Outfitters has recently configured MobileConnect and wants to perform single send-outs from within MobileConnect using data extensions that contain automatically refreshed segments.
Which two fields would need to be added to enable these data extensions for sending? (Choose 2 answers)

Question41: Northern Trail Outfitters wants to have a periodic, dynamic newsletter send to a set data extension, but the data in this data extension will be regularly updated and the subscribers inside could be removed/added multiple times.
What option should speed up the delivery while meeting these criteria?

Question42: Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Orders when they are either created or updated with a status of New, Currently Knitting Shipped, and Complete. Their Journey works when orders are created, but they notice that it does not inject customers when their status is updated.
What could be causing this?

Question43: A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices.
Which reasons warrants this implementation? Choose 2 answers.

Question44: A B2B customer notices they have a large number of subscribers marked as 'Held'. During troubleshooting, they realize these were soft bounces from overwhelming the email servers of many of the small companies with which they do business.
What step(s) should the customer take to move those subscribers back to 'Active'?

Question45: Which data object should be used in conjunction with data extensions to create an opt- down strategy for customers?

Question46: Northern Trail Outfitters is having their regional supplier conference and wants to allow attendees to request event-specific safety notifications, schedule or room changes, and surprise pop-up sessions.
Which solution should they use?

Question47: A customer manages their field technicians in Salesforce CRM connected to Marketing Cloud. Once an appointment with a contact is scheduled for the technician through CRM, the notification message should be sent to the contact informing them about the scheduled visit date. When the notification is sent the "Confirmation sent" checkbox on the appointment record should be updated in CRM.
All appointments scheduled on a given day will have their status updated in CRM at the end of business hours. The Appointment object does not have a direct relationship with the contact.
What solution would a consultant recommend to address this use case?

Question48: Northern Trail Outfitters' marketing team is made up of a marketing manager, a marketing specialist, and a graphic designer. The team is new to Marketing Cloud and has very little coding experience. Currently, they use Excel and VLOOKUP to segment their email audiences and import them into Marketing Cloud.
What solution should be recommended to allow for long-term self-sufficiency in segmentation?

Question49: A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow up to those who have engaged with the content.
The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between contact > person account > real estate agent > property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.
What solution should be recommended for execution efficiency?

Question50: Northern Trail Outfitters wants to send a welcome email to Contacts when a Contact record is added as a campaign Member to a 'Loyalty Member' Campaign in Sales Cloud.
Which method should they use to send the email from Marketing Cloud?

Question51: A customer needs to import data from an SFTP site. The customer wants to:
* Segment the contents of the file and then send emails.
* Transfer the file to the SFTP site at various times daily.
* Send to data extensions.
What sequence of automation activities should meet these requirements?

Question52: When Northern Trail Outfitters acquires a new customer, it would like to send a series of welcome messages on behalf of the brand with an optimized send time. New customers will be sent to Marketing Cloud via an hourly batch file drop.
Which solution should the consultant recommend?

Question53: During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria:
* Customer data will be fully refreshed every night via Import activity from the customer's data warehouse.
* Contact records will be augmented by relational data tables via Contact Builder.
* The customer data file will contain 5M records with 40+ attributes.
* One attribute will house HTML code, 1000 characters max, that will be used to populate Account Access content areas in emails.
* A customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists?

Question54: Northern Trail Outfitters recently purchased Marketing Cloud to start running cross-channel campaigns. They are looking for guidance on which value to use as the subscriber key.
Which two options should the consultant recommend? (Choose 2 answers)

Question55: Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, Is housed in a separate data extension than the one used for Journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the Journey source and transaction data extensions.
Which activity would they use to accomplish this?

Question56: Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase the last six months. Customer are often opted-in to more than one messaging channel. NTO would like to be able to communicate the same message across all channels.
Which flow would meet their needs?

Question57: A pharmaceutical company is hosting a monthly event and will be sending an invitation to new local contacts. The customer would like to automatically update a data extension to determine who will be attending.
*The data extension will hold each contact's response as well as the time stamp of the click.
*The contact will receive an email two days after the click event.
*Both emails should be sent via Journey Builder.
What is the optimal solution to record the click activity prior to sending the second email?

Question58: Northern Trail Outfitters (NTO) has doubled in size over the last couple of years. Because of this growth they have decided to organize their company into Business Units to better manage operations.
Which statement is correct regarding the Business Unit functionality within Marketing Cloud?
Choose 2 answers

Question59: Northern Trail Outfitters has determined they will initially deploy messaging to email and SMS channels, but also plan for social advertising. Customer data originates within their point-of-sale system which communicates to Marketing Cloud in real-time via API. They want to configure their customer data for long-term cleanliness and maintainability.
Which two best practices should be utilized? (Choose 2 answers)

Question60: Northern Trail Outfitters wants to include a 'view online' link in an email template to enable users to view a web page version of the email.
Which personalization string should they include as the href attribute in the link?

Question61: Northern Trail Outfitters (NTO) wants to better understand subscriber behavior on their website upon arrival via an email message. A local member of a Marketing Cloud user group mentioned the Web Analytics Connector.
Which benefit is offered by installing the Web Analytics Connector in a Marketing Cloud account?
Choose 3 answers

Question62: How do I set up an individual who manages Marketing Cloud operations across channels, mobile, and social? Choose two.

Question63: Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeros, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

Question64: A marketer want to personalize an email with real-time weather information from the Sunny Sky API.
What tool should be used to parse and display the response within the email?

Question65: Northern Trail Outfitters wants to query Marketing Cloud for send data across SMS, Push, and email.
What would a consultant recommend?

Question66: What are two ways Contact builder can alter the data in Data Extensions

Question67: NTO has to import a file that will be different every time.
What method should be used?

Question68: Northern Trail Outfitters wants to capture dietary preferences for Contacts who have registered for an upcoming launch event. They have created a data extension of Contacts who have registered for the event and will send them an SMS message from MobileConnect asking them to reply with their dietary preference. When Contact reply to SMS message, the response message will be inserted into a data extension using AMPscript.
Which two MobileConnect templates should be used to send the SMS message and capture the responses?

Question69: Northern Trail Outfitters (NTO) stores customer purchase data m an external system. NTO ingests this data into Marketing Cloud through a file drop automation. The automation contains an import activity which overwrites a staging data extension, as well as an SQL Query activity which brings this data into a sendable data extension.
NTO's marketing manager wants to be informed If mort than 1,000 records are ever imported through this automation, and would also like to prevent the sendable date extension from being updated that day.
Which solution ts appropriate m this situation'A. Q Split the existing activities into two separate automations.

Question70: Tracking Alias question:

Question71: Which three statements about Send Log Data is correct?

Question72: A customer with limited technical resources has assistance in setting up a small email deployment that the customer will maintain long term. The email will display men's shoes to males in the audience and women's shoes to females in the audience. The sendable data extension contains a field with a value of Male or Female.
Which method should a consultant recommend to ensure content is displayed properly within the email?

Question73: A B2B customer has customized journeys they want to use for several key accounts they are trying to sell into.
How could Marketing Cloud Connect be used to initiate these sends when contacts for select accounts are created?

Question74: Northern Trail Outfitters (NTO) plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships. NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database.
What action should be taken when using Contact Builder? Choose 2 answers

Question75: Northern Trail Outfitters wants to include the body of marketing email replies captured by Reply Mail Management (RMM) within auto-forwarded messages to their Customer Success team.
How could they accomplish this?

Question76: Every day at 3 a.m., Northern Trail Outfitter' (NTO) data lake instance starts generating a file that contains all records that should be sent one email or another for the next day's marketing campaigns. The size of the file varies depending on the previous day's tracking activity. As soon as the file is generated, NTO wants to import the data, segment the data, and then execute the daily sends.
What end-to-end process should deliver this efficiently?

Question77: A customer executes a large number of sends via Marketing Cloud connect and is concerned about API limits. What should the consultant suggest to minimize the impact of Marketing Cloud Connect on daily API limits? Choose Two

Question78: A customer has a robust Sales Cloud org with several custom objects. Historically, they have created complex reports, referencing many custom objects, to target subscribers and exported them to another email system for deployment. With the implementation of Marketing Cloud Connect, the customer wants to simplify the sending process using Marketing Cloud with as little additional setup as possible.
What should a consultant recommend to meet this criteria?

Question79: An online retail customer needs daily promotional email content to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose. The customer has communicated the following:
* The email content will highlight new inventory each day.
* A small team will run both their digital marketing operations and their email program.
* A user needs to build, test, and send a daily email in less than an hour.
* Images for the emails will be hosted on their website CMS.
Which question is relevant to identify strategies for designing the custom template for the customer's daily promotional email? Choose 3 answers

Question80: Northern Trail Outfitters (NTO) wants to send an email to all Contacts who have signed up for its newsletter, but have not joined its loyalty program. NTO has created a report in Sales Cloud which it will select using a Send Flow in Content Builder.
Which field name should be included in the report in addition to email address?

Question81: Northern Trail Outfitters (NTO) is migrating from a series of local legacy email automation tools to a single global Marketing Cloud instance to leverage its multi-channels abilities as well as native Salesforce Connector to their global Sales Cloud instance.
Which three factors Should be considered before finalizing the number of business unit they need to purchase? (Choose 3 answers)

Question82: A customer wants to create a journey with the goal of making users activate their accounts
within 72 h of registration. New account registrations are stored in a data extension via an API call with a Boolean field indicating whether the subscriber has activated their account. The journey should send activation reminder emails 24 and 48 h after creating an account. The user exits the journey if they activate their account.
Which activities should be included in the customer's journey?

Question83: A customer wants to automate a series of three emails as part of a Membership renewal drip campaign.
* Email #1 will be sent one month prior to the member's renewal date
* Email #2 will be sent one week prior to the member's renewal date
* Email #3 will be sent on the member's renewal date
* A master audience is updated in real time via the API
Which steps should be included in the customer's automation?

Question84: Northern Trail Outfitters maintains their primary customer identity in their ERP system but managers their customer service via Service Cloud. Customer data is updated in real-time based on changes in the ERP, and the ERP customer ID serves as the Customer Key. They want to leverage Synchronized Data Extensions to import data about cases from Service Cloud every 15 minutes.
What consideration should be made before implementing this solution?

Question85: A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow up to those who have engaged with the content.
The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between contact > person account > real estate agent > property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.
What solution should be recommended for execution efficiency?

Question86: Which two statements are correct about Send Logging? Choose 2 answers

Question87: A retail company's database of record resides at a 3rd-party company that also keeps track of purchase history. That database only updates once a day where new records can be created and merged. The database uses an "Email ID," which is a numeric field that represents both the business unit and email address. The company now wants to be able to send real-time Welcome emails to people (newly registered website users) who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Email ID" in the database.
What key issue should be addressed? Choose 3 answers

Question88: What are the similarities between Automation Studio and Journey Builder?

Question89: Northern Trail Outfitters has acquired a new company and is importing customer data to Marketing Cloud. They want to ensure commercial emails are not sent to email addresses who have previously opted-out.
Which feature should they use?

Question90: Northern Trail Outfitters received an email about reaching API limits within Salesforce and they think this is caused by the integrated Marketing Cloud account.
Which two types of API calls are counted against the rolling 24-hour limit?

Question91: A consultant configured a triggered send definition in Sales Cloud for a customer using Marketing Cloud Connect, The trigger is on a Custom Object called 'Shipments' and is enabled for Triggered Sends in Setup.
Which two configuration requirements should be considered when troubleshooting? (Choose 2 answers)

Question92: Which two statements about a database of record are correct? Choose 2 answers

Question93: A user in Marketing Cloud needs to send an email to a Salesforce Report via a Guided Send process.
How should the consultant meet this requirement?

Question94: A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The owners of franchised stores add a customized local message to the marketing campaign.
What hierarchy should be recommended?

Question95: Northern Trail Outfitters wants to monitor available coupon codes and sends a notification to their email specialist instructing them to request more codes for importing if the available coupon count falls below 500 available codes.
Which two activities would be automation?
Choose 2 answers

Question96: Northern Trail Outfitters wants a simple segmentation strategy for identifying subscribers for their emails.
What solution should they use?

Question97: How do you use data designer to link the web analytics data to your subscriber data?

Question98: Northern Trail Outfitters wants to create a query to populate a data extension with email subscribers who belong to a specific publication list.
Which Data View could they use to achieve this?

Question99: Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase the last six months. Customer are often opted-in to more than one messaging channel. NTO would like to be able to communicate the same message across all channels.
Which flow would meet their needs?

Question100: A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails.
What should a consultant recommend'

Question101: A customer's marketing manager will use Social Pages to manage the company's Facebook page.
Which role should the marketing manager have in the Marketing Cloud?
Choose one answer

Question102: A customer notices their open and click rates are very low.
Which two aspects of list hygiene should be recommended to improve engagement rates? (Choose 2 answers)

Question103: North Trail Outfitters (NTO) wants to automate the sending of shipping notices and a customer survey.
*Shipping notices will be sent once a day.
*The shipping file will be placed on the FTP sometime after 4:00 p.m.
*The shipping data will be stored in the shipping Notice data extension.
*A field in the data extension will contain the shipping data.
*The survey needs to be sent at 9:00 a.m., exactly 10 days after the customers order ships.
Which workflow would most effectively enable NTO to do this?
A)

B)

C)

D)

Question104: Northern Trail Outfitters is using a triggered send to send customers their order confirmations. Their commerce platform provides a JSON payload for order details.
What would they use to format the JSON within the email?

Question105: A customer needs to link demographic information to its model in Contact Builder.
What type of relationship should be used?

Question106: A customer indicates their point-of-sale system can be configured to upload a file every fifteen minutes. The filename is not consistent for each upload. Their consultant recommends they use a File Drop Automation.
Which two considerations should be made?
Choose 2 answers

Question107: A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?

Question108: A customer wants to reports on 'Not Sent' contacts in Journey Builder.
Which method should be used?

Question109: Northern Trail Outfitters upgraded their Marketing Cloud account which now includes a Sender Authentication Package (SAP), They send regularly 300,000 What should they be aware of with respect to sender reputation?

Question110: Northern Trail Outfitters is sending Salesforce Triggered Sends using Marketing Cloud Connect. The sends have a status of failed.
What shouifl the consultant do to diagnose tne Issue?

Question111: Northern Trail Outfitters recently purchased Marketing Cloud to start running cross-channel campaigns. They are looking for guidance on which value to use as the subscriber key.
Which two options should the consultant recommend? (Choose 2 answers)

Question112: A customer wants to send a quarterly reengagement email to subscribers who have NOT opened in the previous three months. The customer's plans are to:
* Use an existing Paste HTML email for the first send.
* Make only minor changes to the email creative for future sends.
* Send to the subscriber list.
* Deploy emails manually for now, but possibly automate in the future.
Which send method should be used?

Question113: Northern Trail Outfitters (NTO) is the holding company of three subsidiaries: Universal Containers, Ursa Major Solar, and Cloud Kicks. NTO recently purchased Marketing Cloud and has asked its consultant to recommend a scalable business unit (BU) hierarchy. They don't plan on executing any marketing campaigns on behalf of the NTO holding company, but NTO employees would like access to all subscribers and aggregate reporting. Additionally, each subsidiary business will be regularly running campaigns and should have their own branding, content, and subscribers.
Which solution should the consultant recommend?

Question114: A retail company needs to create journeys that will target subscribers based on website behavior. They have identified 3 separate groups:
* Customers who searched for an item on their website.
* Customers who abandoned a cart on their website.
* Customers who made a purchase on their website.
What should the consultant ask in order to design the data structure for this solution? Choose 3 answers

Question115: Northern Trail Outfitters has master data extension of 880,000 subscribers they want to randomly split into 11 groups to test different messaging strategies.
How could this be accomplished?

Question116: A Marketing Cloud user needs the email addresses of everyone who unsubscribed from a particular email send. This user does NOT know SQL and does NOT have access to the Enhanced FTP account.
What functionality should be used to retrieve the necessary data?

Question117: Northern Trail Outfitters wants to import new contacts gathered from an external web form. The entries are being collected at high frequency, potentially thousands per minutes. The data does not need to be immediately ingested into Marketing Cloud as it is used in a daily scheduled automation.
What Should be recommended?

Question118: A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The corporate office the advertising copy and subscriber list. The owners of franchised stores add a customized local message to the marketing campaign.
What hierarchy should be recommended?

Question119: A customer's web developer team is creating a form that will leverage a Marketing Cloud REST API endpoint to upsert rows into a data extension.
How should the consultant create an installed package in Marketing Cloud to facilitate this functionality?

Question120: Northern Trail Outfitters wants to target all customers who have registered to receive Push Notifications. Their app uses the Mobile Push SDK.
In which two ways should this segment be created?

Question121: A financial company wans to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following:
*Payment.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.
*Payments.csv will be encrypted.
*Payments.csv will contain data from the previous week.
*Late payment notices will be sent each Monday at noon.
*They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send.
Which automation sequence represents a viable solution?

Question122: An existing triggered send needs to be updated with new content
Select the correct sequence

Question123: A user in Marketing Cloud needs to send an email to a Salesforce Report via a Guided Send process.
How should the consultant meet this requirement?

Question124: Northern Trail Outfitters injects customers into journey B based upon email engagement in journey A.
Which method would facilitate this solution?

Question125: A customer wants to integrate their website with Marketing Cloud so that users can update their marketing communication preferences. The customer has in-house web development resources available and is interested in leveraging tools such as Journey Builder in the future.
What solution should the consultant propose, given the customer's requirements and available resources?

Question126: Which three statements are correct regarding the automation tools in Marketing Cloud?
Choose 3 answers

Question127: Northern Trail Outfitters (NTO) wants to use dynamic content within their emails to provide customers with more personalized communications. This includes using a Dynamic Sender Profile to customize the From Name and From Email Address to use the regional store managers' information. If a new manager is assigned to a region, NTO wants to update the information in one place.
What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?

Question128: Northern Trail Outfitters has configured Reply Mall Management to handle manual unsubscribe requests. However, they have received complaints from customers who are still getting marketing emails despite having sent multiple unsubscribe replies including phrases like "take me off your list" or "opt out".
How could this behavior be corrected'

Question129: When joining a data extension in Contact Builder, in which scenario should a consultant mark the Use as Root checkbox?

Question130: A customer wants to perform an email send to a subset of Synchronized Data Extension referencing Sales Cloud custom object data and return tracking to Sales Cloud.
Which two approaches should the consultant recommend?
Choose 2 answers

Question131: What functionality is contained in Journey Builder that does NOT exist in Automation Studio?

Question132: Northern Trail Outfitters wants to implement a Welcome email. New subscribers signing up on their website should receive the email promptly. They are utilizing Marketing Cloud Connect to connect Sales Cloud and Marketing Cloud.
Which solution should capture the new subscribers?

Question133: Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer.
How should they accomplish this task?

Question134: What are two possible outcomes when "Multipart MIME" is selected during the send process? Choose 2 answers